from sqlalchemy import Column
from sqlalchemy.sql.sqltypes import Integer, String, Text, TIMESTAMP
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class Annualreport(Base):
    __tablename__ = "TYC_IC_ANNUALREPORT"
    RELEASETIME = Column(String(255))
    BASEINFO = Column(Text)
    COMPANYID = Column(String(20))
    OUTBOUNDINVESTMENTLIST = Column(Text)
    SHAREHOLDERLIST = Column(Text)
    REPORTSOCIALSECURITYINFO = Column(Text)
    GOVREPORT = Column(String(100))
    EQUITYCHANGEINFOLIST = Column(Text)
    TYPE = Column(Integer)
    CHANGERECORDLIST = Column(Text)
    WEBINFOLIST = Column(Text)
    OUTGUARANTEEINFOLIST = Column(Text)

    ENTNAME = Column(String(100))
    PRIPID = Column(String(36))
    REGNO = Column(String(50))
    UNISCID = Column(String(18))
    CREATE_TIME = Column(TIMESTAMP)
    UPDATE_TIME = Column(TIMESTAMP)